insert overwrite table jms_dim.dim_yl_nwm_area_weight
select
ID
,PROXY_CODE
,PROXY_NAME
,TOP_AREA_INFO_CODE
,TOP_AREA_INFO_NAME
,AREA_INFO_CODE
,AREA_INFO_NAME
,CREATE_BY
,UPDATE_BY
,CREATE_BY_NAME
,UPDATE_BY_NAME
,BUSINESS_FINISH_WEIGHT
,BUSINESS_FINISH_GUARANTEE
,BUSINESS_FINISH_TARGET
,TIMELY_COLLECT_R_WEIGHT
,TIMELY_COLLECT_R_GUARANTEE
,TIMELY_COLLECT_R_TARGET
,TIMELY_DELIVERY_R_WEIGHT
,TIMELY_DELIVERY_R_GUARANTEE
,TIMELY_DELIVERY_R_TARGET
,TIMELY_SIGN_R_WEIGHT
,TIMELY_SIGN_R_GUARANTEE
,TIMELY_SIGN_R_TARGET
,TIME_TO_REFUND_R_WEIGHT
,TIME_TO_REFUND_R_GUARANTEE
,TIME_TO_REFUND_R_TARGET
,LOSS_RATE_WEIGHT
,LOSS_RATE_GUARANTEE
,LOSS_RATE_TARGET
,DAMAGE_RATE_WEIGHT
,DAMAGE_RATE_GUARANTEE
,DAMAGE_RATE_TARGET
,CUSTOMER_CR_WEIGHT
,CUSTOMER_CR_GUARANTEE
,CUSTOMER_CR_TARGET
,FALSE_RECEIPT_WEIGHT
,FALSE_RECEIPT_GUARANTEE
,FALSE_RECEIPT_TARGET
,WEIGHT10
,GUARANTEE10
,TARGET10
,WEIGHT11
,GUARANTEE11
,TARGET11
,WEIGHT12
,GUARANTEE12
,TARGET12
,WEIGHT13
,GUARANTEE13
,TARGET13
,WEIGHT14
,GUARANTEE14
,TARGET14
,WEIGHT15
,GUARANTEE15
,TARGET15
,CREATE_TIME
,UPDATE_TIME
,START_DATE
,END_DATE
,CREATE_CODE
,UPDATE_CODE
from jms_ods.yl_nwm_area_weight where dt= '{{ execution_date | cst_ds }}'
distribute by 1 ;